Node / meshtastic / Meshtastic-Android / files / core / database / src / commonMain / kotlin / org / meshtastic / core / database / dao / DiscoveryDao.kt

Displaying Raw • Download

T8b949e/*

* Copyright (c) 2026 Meshtastic LLC

*

* This program is free software: you can redistribute it and/or modify

* it under the terms of the GNU General Public License as published by

* the Free Software Foundation, either version 3 of the License, or

* (at your option) any later version.

*

* This program is distributed in the hope that it will be useful,

* but WITHOUT ANY WARRANTY; without even the implied warranty of

* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

* GNU General Public License for more details.

*

* You should have received a copy of the GNU General Public License

* along with this program. If not, see <https://www.gnu.org/licenses/>.

*/

Tff7b72package T7ee787org.meshtastic.core.database.dao

Tff7b72import T7ee787androidx.room3.Dao

Tff7b72import T7ee787androidx.room3.Insert

Tff7b72import T7ee787androidx.room3.Query

Tff7b72import T7ee787androidx.room3.Transaction

Tff7b72import T7ee787androidx.room3.Update

Tff7b72import T7ee787kotlinx.coroutines.flow.Flow

Tff7b72import T7ee787org.meshtastic.core.database.entity.DiscoveredNodeEntity

Tff7b72import T7ee787org.meshtastic.core.database.entity.DiscoveryPresetResultEntity

Tff7b72import T7ee787org.meshtastic.core.database.entity.DiscoverySessionEntity

Tff7b72import T7ee787org.meshtastic.core.database.entity.DiscoverySessionStatus

Tf0883e@Dao

Tf0883e@SuppressTb4b4b4(Ta5d6ff"Ta5d6ffTooManyFunctionsTa5d6ff"Tb4b4b4)

Tff7b72interface T56d364DiscoveryDao Tb4b4b4{

T8b949e// region Session operations

Tf0883e@Insert Tff7b72suspend Tff7b72fun Td2a8ffinsertSessionTb4b4b4(Te6edf3sessionTb4b4b4: Te6edf3DiscoverySessionEntityTb4b4b4)Tb4b4b4: Tffa657Long

Tf0883e@Update Tff7b72suspend Tff7b72fun Td2a8ffupdateSessionTb4b4b4(Te6edf3sessionTb4b4b4: Te6edf3DiscoverySessionEntityTb4b4b4)

Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM discovery_session ORDER BY timestamp DESCTa5d6ff"Tb4b4b4)

Tff7b72fun Td2a8ffgetAllSessionsTb4b4b4(Tb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Te6edf3ListTff7b72<Te6edf3DiscoverySessionEntityTff7b72>Tff7b72>

T8b949e/** Snapshot used by DatabaseMerger to append a transport's discovery sessions to the unified DB. */

Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM discovery_sessionTa5d6ff"Tb4b4b4)

Tff7b72suspend Tff7b72fun Td2a8ffgetAllSessionsSnapshotTb4b4b4(Tb4b4b4)Tb4b4b4: Te6edf3ListTff7b72<Te6edf3DiscoverySessionEntityTff7b72>

Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM discovery_session WHERE id = :sessionIdTa5d6ff"Tb4b4b4)

Tff7b72suspend Tff7b72fun Td2a8ffgetSessionTb4b4b4(Te6edf3sessionIdTb4b4b4: Tffa657LongTb4b4b4)Tb4b4b4: Te6edf3DiscoverySessionEntity?

Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffUPDATE discovery_session SET completion_status = :status WHERE id = :sessionIdTa5d6ff"Tb4b4b4)

Tff7b72suspend Tff7b72fun Td2a8ffupdateSessionCompletionStatusTb4b4b4(Te6edf3sessionIdTb4b4b4: Tffa657LongTb4b4b4, Te6edf3statusTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Tffa657Int

Tf0883e@QueryTb4b4b4(

Ta5d6ff"Ta5d6ffUPDATE discovery_session SET total_unique_nodes = :totalUniqueNodes, Ta5d6ff" Tff7b72+

Ta5d6ff"Ta5d6fftotal_dwell_seconds = :totalDwellSeconds, total_messages = :totalMessages, Ta5d6ff" Tff7b72+

Ta5d6ff"Ta5d6fftotal_sensor_packets = :totalSensorPackets, Ta5d6ff" Tff7b72+

Ta5d6ff"Ta5d6fffurthest_node_distance = :furthestNodeDistance, avg_channel_utilization = :avgChannelUtilization Ta5d6ff" Tff7b72+

Ta5d6ff"Ta5d6ffWHERE id = :sessionIdTa5d6ff"Tb4b4b4,

Tb4b4b4)

Tff7b72suspend Tff7b72fun Td2a8ffupdateSessionAggregatesTb4b4b4(

Te6edf3sessionIdTb4b4b4: Tffa657LongTb4b4b4,

Te6edf3totalUniqueNodesTb4b4b4: Tffa657IntTb4b4b4,

Te6edf3totalDwellSecondsTb4b4b4: Tffa657LongTb4b4b4,

Te6edf3totalMessagesTb4b4b4: Tffa657IntTb4b4b4,

Te6edf3totalSensorPacketsTb4b4b4: Tffa657IntTb4b4b4,

Te6edf3furthestNodeDistanceTb4b4b4: Tffa657DoubleTb4b4b4,

Te6edf3avgChannelUtilizationTb4b4b4: Tffa657DoubleTb4b4b4,

Tb4b4b4)

Tf0883e@QueryTb4b4b4(

Ta5d6ff"Ta5d6ffUPDATE discovery_session SET completion_status = :status WHERE id = :sessionId Ta5d6ff" Tff7b72+

Ta5d6ff"Ta5d6ffAND completion_status IN (Ta5d6ff" Tff7b72+

Te6edf3DiscoverySessionStatusTb4b4b4.Te6edf3RECOVERABLE_SQL_LIST Tff7b72+

Ta5d6ff"Ta5d6ff)Ta5d6ff"Tb4b4b4,

Tb4b4b4)

Tff7b72suspend Tff7b72fun Td2a8ffupdateRecoverableSessionCompletionStatusTb4b4b4(Te6edf3sessionIdTb4b4b4: Tffa657LongTb4b4b4, Te6edf3statusTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Tffa657Int

Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM discovery_session WHERE id = :sessionIdTa5d6ff"Tb4b4b4)

Tff7b72fun Td2a8ffgetSessionFlowTb4b4b4(Te6edf3sessionIdTb4b4b4: Tffa657LongTb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Te6edf3DiscoverySessionEntity?Tff7b72>

Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffDELETE FROM discovery_session WHERE id = :sessionIdTa5d6ff"Tb4b4b4)

Tff7b72suspend Tff7b72fun Td2a8ffdeleteSessionTb4b4b4(Te6edf3sessionIdTb4b4b4: Tffa657LongTb4b4b4)

Tf0883e@QueryTb4b4b4(

Ta5d6ff"Ta5d6ffUPDATE discovery_session SET completion_status = 'Ta5d6ff" Tff7b72+

Te6edf3DiscoverySessionStatusTb4b4b4.Te6edf3INTERRUPTED Tff7b72+

Ta5d6ff"Ta5d6ff' WHERE completion_status = 'Ta5d6ff" Tff7b72+

Te6edf3DiscoverySessionStatusTb4b4b4.Te6edf3IN_PROGRESS Tff7b72+

Ta5d6ff"Ta5d6ff'Ta5d6ff"Tb4b4b4,

Tb4b4b4)

Tff7b72suspend Tff7b72fun Td2a8ffmarkInterruptedSessionsTb4b4b4(Tb4b4b4)

T8b949e/**

* The most recent recoverable session for [deviceAddress]. This includes active/interrupted scans and terminal

* scans whose home-radio restoration is still pending, so callers must inspect completionStatus rather than

* assuming an unfinished scan.

*/

Tf0883e@QueryTb4b4b4(

Ta5d6ff"Ta5d6ffSELECT * FROM discovery_session Ta5d6ff" Tff7b72+

Ta5d6ff"Ta5d6ffWHERE device_address = :deviceAddress Ta5d6ff" Tff7b72+

Ta5d6ff"Ta5d6ffAND completion_status IN (Ta5d6ff" Tff7b72+

Te6edf3DiscoverySessionStatusTb4b4b4.Te6edf3RECOVERABLE_SQL_LIST Tff7b72+

Ta5d6ff"Ta5d6ff) ORDER BY timestamp DESC LIMIT 1Ta5d6ff"Tb4b4b4,

Tb4b4b4)

Tff7b72suspend Tff7b72fun Td2a8ffgetInterruptedSessionTb4b4b4(Te6edf3deviceAddressTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Te6edf3DiscoverySessionEntity?

T8b949e// endregion

T8b949e// region Preset result operations

Tf0883e@Insert Tff7b72suspend Tff7b72fun Td2a8ffinsertPresetResultTb4b4b4(Te6edf3resultTb4b4b4: Te6edf3DiscoveryPresetResultEntityTb4b4b4)Tb4b4b4: Tffa657Long

Tf0883e@Update Tff7b72suspend Tff7b72fun Td2a8ffupdatePresetResultTb4b4b4(Te6edf3resultTb4b4b4: Te6edf3DiscoveryPresetResultEntityTb4b4b4)

Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM discovery_preset_result WHERE session_id = :sessionIdTa5d6ff"Tb4b4b4)

Tff7b72suspend Tff7b72fun Td2a8ffgetPresetResultsTb4b4b4(Te6edf3sessionIdTb4b4b4: Tffa657LongTb4b4b4)Tb4b4b4: Te6edf3ListTff7b72<Te6edf3DiscoveryPresetResultEntityTff7b72>

Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM discovery_preset_result WHERE session_id = :sessionIdTa5d6ff"Tb4b4b4)

Tff7b72fun Td2a8ffgetPresetResultsFlowTb4b4b4(Te6edf3sessionIdTb4b4b4: Tffa657LongTb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Te6edf3ListTff7b72<Te6edf3DiscoveryPresetResultEntityTff7b72>Tff7b72>

T8b949e// endregion

T8b949e// region Discovered node operations

Tf0883e@Insert Tff7b72suspend Tff7b72fun Td2a8ffinsertDiscoveredNodeTb4b4b4(Te6edf3nodeTb4b4b4: Te6edf3DiscoveredNodeEntityTb4b4b4)Tb4b4b4: Tffa657Long

Tf0883e@Insert Tff7b72suspend Tff7b72fun Td2a8ffinsertDiscoveredNodesTb4b4b4(Te6edf3nodesTb4b4b4: Te6edf3ListTff7b72<Te6edf3DiscoveredNodeEntityTff7b72>Tb4b4b4)

Tf0883e@Update Tff7b72suspend Tff7b72fun Td2a8ffupdateDiscoveredNodeTb4b4b4(Te6edf3nodeTb4b4b4: Te6edf3DiscoveredNodeEntityTb4b4b4)

Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM discovered_node WHERE preset_result_id = :presetResultIdTa5d6ff"Tb4b4b4)

Tff7b72suspend Tff7b72fun Td2a8ffgetDiscoveredNodesTb4b4b4(Te6edf3presetResultIdTb4b4b4: Tffa657LongTb4b4b4)Tb4b4b4: Te6edf3ListTff7b72<Te6edf3DiscoveredNodeEntityTff7b72>

Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM discovered_node WHERE preset_result_id = :presetResultIdTa5d6ff"Tb4b4b4)

Tff7b72fun Td2a8ffgetDiscoveredNodesFlowTb4b4b4(Te6edf3presetResultIdTb4b4b4: Tffa657LongTb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Te6edf3ListTff7b72<Te6edf3DiscoveredNodeEntityTff7b72>Tff7b72>

Tf0883e@QueryTb4b4b4(

Ta5d6ff"""

Ta5d6ff SELECT DISTINCT node_num FROM discovered_node dn

INNER JOIN discovery_preset_result dpr ON dn.preset_result_id = dpr.id

WHERE dpr.session_id = :sessionId

Ta5d6ff"""Tb4b4b4,

Tb4b4b4)

Tff7b72suspend Tff7b72fun Td2a8ffgetUniqueNodeNumsTb4b4b4(Te6edf3sessionIdTb4b4b4: Tffa657LongTb4b4b4)Tb4b4b4: Te6edf3ListTff7b72<Tffa657LongTff7b72>

T8b949e// endregion

T8b949e// region Aggregate queries

Tf0883e@QueryTb4b4b4(

Ta5d6ff"""

Ta5d6ff SELECT COUNT(DISTINCT node_num) FROM discovered_node dn

INNER JOIN discovery_preset_result dpr ON dn.preset_result_id = dpr.id

WHERE dpr.session_id = :sessionId

Ta5d6ff"""Tb4b4b4,

Tb4b4b4)

Tff7b72suspend Tff7b72fun Td2a8ffgetUniqueNodeCountTb4b4b4(Te6edf3sessionIdTb4b4b4: Tffa657LongTb4b4b4)Tb4b4b4: Tffa657Int

Tf0883e@QueryTb4b4b4(

Ta5d6ff"""

Ta5d6ff SELECT MAX(distance_from_user) FROM discovered_node dn

INNER JOIN discovery_preset_result dpr ON dn.preset_result_id = dpr.id

WHERE dpr.session_id = :sessionId

Ta5d6ff"""Tb4b4b4,

Tb4b4b4)

Tff7b72suspend Tff7b72fun Td2a8ffgetMaxDistanceTb4b4b4(Te6edf3sessionIdTb4b4b4: Tffa657LongTb4b4b4)Tb4b4b4: Tffa657Double?

Tf0883e@Transaction

Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM discovery_session WHERE id = :sessionIdTa5d6ff"Tb4b4b4)

Tff7b72suspend Tff7b72fun Td2a8ffgetSessionWithResultsTb4b4b4(Te6edf3sessionIdTb4b4b4: Tffa657LongTb4b4b4)Tb4b4b4: Te6edf3DiscoverySessionEntity?

T8b949e// endregion

Tb4b4b4}